Overview

Dataset statistics

Number of variables7
Number of observations977
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory61.1 KiB
Average record size in memory64.0 B

Variable types

DateTime1
Numeric6

Alerts

ATR_15 is highly overall correlated with ATR_DiffHigh correlation
ATR_Diff is highly overall correlated with ATR_15High correlation
Date has unique valuesUnique
Volatility has unique valuesUnique
ATR has unique valuesUnique
ATR_Diff has unique valuesUnique
ATR_AvgDiff has unique valuesUnique
Volatility_Pct has 282 (28.9%) zerosZeros

Reproduction

Analysis started2023-08-12 21:18:36.285399
Analysis finished2023-08-12 21:18:38.927382
Duration2.64 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

Date
Date

UNIQUE 

Distinct977
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size15.3 KiB
Minimum2019-09-04 00:00:00
Maximum2023-07-21 00:00:00
2023-08-12T17:18:38.984539image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-08-12T17:18:39.075536image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

Volatility
Real number (ℝ)

UNIQUE 

Distinct977
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.29795413
Minimum0.1366133
Maximum0.67081013
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size15.3 KiB
2023-08-12T17:18:39.174082image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0.1366133
5-th percentile0.1464568
Q10.19503982
median0.25302141
Q30.38528347
95-th percentile0.58659976
Maximum0.67081013
Range0.53419684
Interquartile range (IQR)0.19024365

Descriptive statistics

Standard deviation0.13212256
Coefficient of variation (CV)0.44343256
Kurtosis-0.15195204
Mean0.29795413
Median Absolute Deviation (MAD)0.086652933
Skewness0.87184766
Sum291.10118
Variance0.017456371
MonotonicityNot monotonic
2023-08-12T17:18:39.317148image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.6310849613 1
 
0.1%
0.1446476957 1
 
0.1%
0.1403134024 1
 
0.1%
0.1397774805 1
 
0.1%
0.1390928109 1
 
0.1%
0.1366132991 1
 
0.1%
0.1372687538 1
 
0.1%
0.1401639691 1
 
0.1%
0.1398328631 1
 
0.1%
0.1371712688 1
 
0.1%
Other values (967) 967
99.0%
ValueCountFrequency (%)
0.1366132991 1
0.1%
0.1371712688 1
0.1%
0.1372687538 1
0.1%
0.1390928109 1
0.1%
0.1391284685 1
0.1%
0.1397774805 1
0.1%
0.1398328631 1
0.1%
0.1401434062 1
0.1%
0.1401639691 1
0.1%
0.1403134024 1
0.1%
ValueCountFrequency (%)
0.6708101342 1
0.1%
0.6637969 1
0.1%
0.6634223563 1
0.1%
0.656498302 1
0.1%
0.6533745299 1
0.1%
0.6381838394 1
0.1%
0.6344517332 1
0.1%
0.6320163622 1
0.1%
0.6310849613 1
0.1%
0.6310701205 1
0.1%

Volatility_Pct
Real number (ℝ)

ZEROS 

Distinct608
Distinct (%)62.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.33547262
Minimum0
Maximum1
Zeros282
Zeros (%)28.9%
Negative0
Negative (%)0.0%
Memory size15.3 KiB
2023-08-12T17:18:39.413196image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0.17325386
Q30.64662994
95-th percentile1
Maximum1
Range1
Interquartile range (IQR)0.64662994

Descriptive statistics

Standard deviation0.36780011
Coefficient of variation (CV)1.096364
Kurtosis-1.0568009
Mean0.33547262
Median Absolute Deviation (MAD)0.17325386
Skewness0.7058518
Sum327.75675
Variance0.13527692
MonotonicityNot monotonic
2023-08-12T17:18:39.506240image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 282
28.9%
1 89
 
9.1%
0.5122979073 1
 
0.1%
0.6788182219 1
 
0.1%
0.02597071167 1
 
0.1%
0.1406861954 1
 
0.1%
0.1275669697 1
 
0.1%
0.02595158352 1
 
0.1%
0.1962605414 1
 
0.1%
0.4053262474 1
 
0.1%
Other values (598) 598
61.2%
ValueCountFrequency (%)
0 282
28.9%
0.0001172363013 1
 
0.1%
0.0007118102455 1
 
0.1%
0.002919963636 1
 
0.1%
0.003504825518 1
 
0.1%
0.004206914882 1
 
0.1%
0.004494435195 1
 
0.1%
0.004770500663 1
 
0.1%
0.005314884833 1
 
0.1%
0.005848173519 1
 
0.1%
ValueCountFrequency (%)
1 89
9.1%
0.9998854605 1
 
0.1%
0.9982278854 1
 
0.1%
0.9968303108 1
 
0.1%
0.9962741184 1
 
0.1%
0.993797333 1
 
0.1%
0.9930661682 1
 
0.1%
0.9876516458 1
 
0.1%
0.9862088751 1
 
0.1%
0.9861750143 1
 
0.1%

ATR
Real number (ℝ)

UNIQUE 

Distinct977
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3.2702778
Minimum0.90546456
Maximum5.8828374
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size15.3 KiB
2023-08-12T17:18:39.597814image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0.90546456
5-th percentile1.0389449
Q12.5343863
median3.2335128
Q34.1748603
95-th percentile5.1046306
Maximum5.8828374
Range4.9773728
Interquartile range (IQR)1.6404739

Descriptive statistics

Standard deviation1.1865822
Coefficient of variation (CV)0.36283835
Kurtosis-0.5811186
Mean3.2702778
Median Absolute Deviation (MAD)0.84798792
Skewness-0.16912985
Sum3195.0614
Variance1.4079773
MonotonicityNot monotonic
2023-08-12T17:18:39.688850image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1.167241699 1
 
0.1%
4.741016299 1
 
0.1%
4.697285309 1
 
0.1%
4.550799622 1
 
0.1%
4.494079647 1
 
0.1%
4.41980767 1
 
0.1%
4.317820492 1
 
0.1%
4.269965793 1
 
0.1%
4.179968073 1
 
0.1%
4.177970202 1
 
0.1%
Other values (967) 967
99.0%
ValueCountFrequency (%)
0.905464563 1
0.1%
0.9066684064 1
0.1%
0.9127608861 1
0.1%
0.9215571793 1
0.1%
0.9237669254 1
0.1%
0.9307161497 1
0.1%
0.9309350304 1
0.1%
0.9329580923 1
0.1%
0.9337120317 1
0.1%
0.936120034 1
0.1%
ValueCountFrequency (%)
5.882837382 1
0.1%
5.865981556 1
0.1%
5.856916119 1
0.1%
5.8121665 1
0.1%
5.795436394 1
0.1%
5.7913554 1
0.1%
5.790824708 1
0.1%
5.780144954 1
0.1%
5.729468623 1
0.1%
5.694455045 1
0.1%

ATR_15
Real number (ℝ)

HIGH CORRELATION 

Distinct858
Distinct (%)87.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean7.709089
Minimum0.03
Maximum27.58
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size15.3 KiB
2023-08-12T17:18:39.774549image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0.03
5-th percentile0.69
Q13.41
median6.82
Q311.16
95-th percentile17.818
Maximum27.58
Range27.55
Interquartile range (IQR)7.75

Descriptive statistics

Standard deviation5.36862
Coefficient of variation (CV)0.69640134
Kurtosis0.14168657
Mean7.709089
Median Absolute Deviation (MAD)3.74
Skewness0.75895327
Sum7531.78
Variance28.82208
MonotonicityNot monotonic
2023-08-12T17:18:39.861163image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
6.25 4
 
0.4%
2.25 4
 
0.4%
5.97 4
 
0.4%
1.02 3
 
0.3%
7.03 3
 
0.3%
2.54 3
 
0.3%
5.91 3
 
0.3%
6.77 3
 
0.3%
4.08 3
 
0.3%
4.17 3
 
0.3%
Other values (848) 944
96.6%
ValueCountFrequency (%)
0.03 2
0.2%
0.04 1
0.1%
0.05 1
0.1%
0.08 1
0.1%
0.09 1
0.1%
0.12 1
0.1%
0.13 1
0.1%
0.19 1
0.1%
0.2 1
0.1%
0.22 1
0.1%
ValueCountFrequency (%)
27.58 1
0.1%
26.58 1
0.1%
25.86 1
0.1%
25.08 1
0.1%
24.36 1
0.1%
23.84 1
0.1%
23.44 1
0.1%
22.77 1
0.1%
22.08 1
0.1%
22.06 1
0.1%

ATR_Diff
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct977
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean4.4388113
Minimum-5.5094686
Maximum23.184721
Zeros0
Zeros (%)0.0%
Negative225
Negative (%)23.0%
Memory size15.3 KiB
2023-08-12T17:18:39.946464image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum-5.5094686
5-th percentile-2.9162231
Q10.39668293
median3.9462028
Q37.4768289
95-th percentile13.926647
Maximum23.184721
Range28.69419
Interquartile range (IQR)7.080146

Descriptive statistics

Standard deviation5.2665736
Coefficient of variation (CV)1.1864829
Kurtosis0.18124057
Mean4.4388113
Median Absolute Deviation (MAD)3.5371035
Skewness0.64547476
Sum4336.7186
Variance27.736798
MonotonicityNot monotonic
2023-08-12T17:18:40.036492image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1.712758301 1
 
0.1%
-3.591016299 1
 
0.1%
4.002714691 1
 
0.1%
5.019200378 1
 
0.1%
3.635920353 1
 
0.1%
7.21019233 1
 
0.1%
6.932179508 1
 
0.1%
8.440034207 1
 
0.1%
7.150031927 1
 
0.1%
17.2720298 1
 
0.1%
Other values (967) 967
99.0%
ValueCountFrequency (%)
-5.509468623 1
0.1%
-4.881052911 1
0.1%
-4.869806296 1
0.1%
-4.8313554 1
0.1%
-4.749977251 1
0.1%
-4.564948545 1
0.1%
-4.530582925 1
0.1%
-4.38966032 1
0.1%
-4.383409544 1
0.1%
-4.345459425 1
0.1%
ValueCountFrequency (%)
23.18472134 1
0.1%
22.64425242 1
0.1%
21.41819454 1
0.1%
21.25921579 1
0.1%
21.1890908 1
0.1%
20.02163303 1
0.1%
19.68689867 1
0.1%
19.59062348 1
0.1%
19.55209658 1
0.1%
19.4892984 1
0.1%

ATR_AvgDiff
Real number (ℝ)

UNIQUE 

Distinct977
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean4.3949329
Minimum-2.0317118
Maximum15.712869
Zeros0
Zeros (%)0.0%
Negative56
Negative (%)5.7%
Memory size15.3 KiB
2023-08-12T17:18:40.127086image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum-2.0317118
5-th percentile-0.17625228
Q11.9940687
median3.9074231
Q36.1502215
95-th percentile10.838367
Maximum15.712869
Range17.74458
Interquartile range (IQR)4.1561528

Descriptive statistics

Standard deviation3.2854393
Coefficient of variation (CV)0.74755164
Kurtosis0.57044928
Mean4.3949329
Median Absolute Deviation (MAD)2.0607679
Skewness0.78744531
Sum4293.8494
Variance10.794111
MonotonicityNot monotonic
2023-08-12T17:18:40.217615image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1.577137045 1
 
0.1%
7.798422898 1
 
0.1%
7.612113577 1
 
0.1%
7.483794894 1
 
0.1%
6.955541901 1
 
0.1%
6.33166133 1
 
0.1%
6.137061686 1
 
0.1%
5.968190906 1
 
0.1%
5.481555957 1
 
0.1%
5.123407782 1
 
0.1%
Other values (967) 967
99.0%
ValueCountFrequency (%)
-2.03171178 1
0.1%
-2.003310241 1
0.1%
-1.914353217 1
0.1%
-1.694689544 1
0.1%
-1.600729669 1
0.1%
-1.334777201 1
0.1%
-1.24759462 1
0.1%
-1.206834035 1
0.1%
-1.085231919 1
0.1%
-1.022236499 1
0.1%
ValueCountFrequency (%)
15.7128686 1
0.1%
15.61554969 1
0.1%
15.39119067 1
0.1%
15.14584714 1
0.1%
15.01183622 1
0.1%
14.94826684 1
0.1%
14.87104134 1
0.1%
14.82644357 1
0.1%
14.81211572 1
0.1%
14.58485514 1
0.1%

Interactions

2023-08-12T17:18:38.352357image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-08-12T17:18:36.350646image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-08-12T17:18:36.756544image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-08-12T17:18:37.145893image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-08-12T17:18:37.533945image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-08-12T17:18:37.967726image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-08-12T17:18:38.419872image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-08-12T17:18:36.417168image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-08-12T17:18:36.820064image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-08-12T17:18:37.207920image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-08-12T17:18:37.600461image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-08-12T17:18:38.029958image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-08-12T17:18:38.487392image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-08-12T17:18:36.483277image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-08-12T17:18:36.882591image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-08-12T17:18:37.273033image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-08-12T17:18:37.665733image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-08-12T17:18:38.095486image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-08-12T17:18:38.553415image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-08-12T17:18:36.554820image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-08-12T17:18:36.946670image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-08-12T17:18:37.334549image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-08-12T17:18:37.729506image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-08-12T17:18:38.158518image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-08-12T17:18:38.621025image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-08-12T17:18:36.623351image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-08-12T17:18:37.011703image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-08-12T17:18:37.396561image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-08-12T17:18:37.795034image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-08-12T17:18:38.220304image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-08-12T17:18:38.692549image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-08-12T17:18:36.685368image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-08-12T17:18:37.077223image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-08-12T17:18:37.463627image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-08-12T17:18:37.864560image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-08-12T17:18:38.283825image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-08-12T17:18:40.282301image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
VolatilityVolatility_PctATRATR_15ATR_DiffATR_AvgDiff
Volatility1.000-0.036-0.418-0.205-0.102-0.208
Volatility_Pct-0.0361.0000.4980.072-0.043-0.039
ATR-0.4180.4981.0000.173-0.0520.096
ATR_15-0.2050.0720.1731.0000.9680.404
ATR_Diff-0.102-0.043-0.0520.9681.0000.391
ATR_AvgDiff-0.208-0.0390.0960.4040.3911.000

Missing values

2023-08-12T17:18:38.802532image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-08-12T17:18:38.886584image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

Sample

DateVolatilityVolatility_PctATRATR_15ATR_DiffATR_AvgDiff
2662019-09-040.6310850.5122981.1672422.881.7127581.577137
2672019-09-050.6201530.2168671.1667591.610.4432411.520395
2682019-09-060.6200290.2135251.1196421.350.2303581.433746
2692019-09-090.6166150.1212471.1316662.381.2483341.477852
2702019-09-100.6095710.0000001.1382211.910.7717791.511906
2712019-09-110.5931430.0000001.1756731.13-0.0456731.377690
2722019-09-120.5926860.0000001.1552950.55-0.6052951.249489
2732019-09-130.6051820.2213921.1769422.010.8330581.283078
2742019-09-160.6004080.1454711.1404791.740.5995211.130784
2752019-09-170.5978140.0966111.0924470.90-0.1924470.973443
DateVolatilityVolatility_PctATRATR_15ATR_DiffATR_AvgDiff
12332023-07-100.1560530.3024662.7744937.835.0555071.721246
12342023-07-110.1564970.3674362.7695267.524.7504742.014585
12352023-07-120.1549250.2133132.8262252.81-0.0162251.878502
12362023-07-130.1542770.1898922.7324760.63-2.1024761.482379
12372023-07-140.1541430.1732542.6536458.696.0363551.823687
12382023-07-170.1514280.0000002.71806815.1212.4019322.347664
12392023-07-180.1515440.0174692.66353013.9111.2464702.718842
12402023-07-190.1500860.0000002.85729516.8914.0327053.371319
12412023-07-200.1511520.1663362.93080915.1412.2091914.110742
12422023-07-210.1519930.2974662.98408813.9010.9159124.858070